if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Invoice_in]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Invoice_in]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Invoice_initem]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Invoice_initem]
GO

CREATE TABLE [dbo].[Invoice_in] (
	[Inv_inID] [bigint] IDENTITY (1, 1) NOT NULL ,
	[Inv_inDate] [datetime] NOT NULL ,
	[Inv_inVNo] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[SessionID] [smallint] NOT NULL ,
	[SupplierID] [int] NULL ,
	[StoreID] [int] NULL ,
	[Remarks] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ReadOnly] [bit] NOT NULL ,
	[LoginID] [int] NOT NULL ,
	[HostName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[EntryDateTime] [datetime] NULL ,
	[ModifyID] [int] NULL ,
	[ModifyHostName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ModifyDateTime] [datetime] NULL ,
	[VehNo] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[SumQTY] [numeric](15, 4) NOT NULL ,
	[SUMGrossWT] [numeric](15, 4) NOT NULL ,
	[SUMNetWT] [numeric](15, 4) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Invoice_initem] (
	[Inv_initemID] [bigint] IDENTITY (1, 1) NOT NULL ,
	[Inv_inID] [bigint] NOT NULL ,
	[LotNo] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ItemID] [smallint] NULL ,
	[VarietyID] [smallint] NULL ,
	[Qty] [numeric](15, 4) NOT NULL ,
	[GrossWT] [numeric](15, 4) NOT NULL ,
	[NetWT] [numeric](15, 4) NOT NULL ,
	[Type] [tinyint] NOT NULL ,
	[DRemarks] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Invoice_in] WITH NOCHECK ADD 
	CONSTRAINT [PK_Invoice_in] PRIMARY KEY  CLUSTERED 
	(
		[Inv_inID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Invoice_initem] WITH NOCHECK ADD 
	CONSTRAINT [PK_Invoice_initem] PRIMARY KEY  CLUSTERED 
	(
		[Inv_initemID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Invoice_in] ADD 
	CONSTRAINT [DF_Invoice_in_ReadOnly] DEFAULT (0) FOR [ReadOnly],
	CONSTRAINT [DF_Invoice_in_LoginID] DEFAULT (1) FOR [LoginID],
	CONSTRAINT [DF_Invoice_in_HostName] DEFAULT (host_name()) FOR [HostName],
	CONSTRAINT [DF_Invoice_in_EntryDateTime] DEFAULT (getdate()) FOR [EntryDateTime],
	CONSTRAINT [DF_Invoice_in_SumQTY] DEFAULT (0) FOR [SumQTY],
	CONSTRAINT [DF_Invoice_in_GrossWT] DEFAULT (0) FOR [SUMGrossWT],
	CONSTRAINT [DF_Invoice_in_SUMNetWT] DEFAULT (0) FOR [SUMNetWT]
GO

ALTER TABLE [dbo].[Invoice_initem] ADD 
	CONSTRAINT [DF_Invoice_initem_Qty] DEFAULT (0) FOR [Qty],
	CONSTRAINT [DF_Invoice_initem_GrossWT] DEFAULT (0) FOR [GrossWT],
	CONSTRAINT [DF_Invoice_initem_NetWT] DEFAULT (0) FOR [NetWT],
	CONSTRAINT [DF_Invoice_initem_Type] DEFAULT (0) FOR [Type]
GO


-----------------------------------------------------------------------------------------------------------------------------------------------------

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Invoice_out]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Invoice_out]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Invoice_outitem]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Invoice_outitem]
GO

CREATE TABLE [dbo].[Invoice_out] (
	[Inv_outID] [bigint] IDENTITY (1, 1) NOT NULL ,
	[Inv_outDate] [datetime] NOT NULL ,
	[Inv_outVNo] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[SessionID] [smallint] NOT NULL ,
	[SupplierID] [int] NULL ,
	[StoreID] [int] NULL ,
	[Remarks] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ReadOnly] [bit] NOT NULL ,
	[LoginID] [int] NOT NULL ,
	[HostName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[EntryDateTime] [datetime] NULL ,
	[ModifyID] [int] NULL ,
	[ModifyHostName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ModifyDateTime] [datetime] NULL ,
	[VehNo] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[SumQTY] [numeric](15, 4) NOT NULL ,
	[SUMGrossWT] [numeric](15, 4) NOT NULL ,
	[SUMNetWT] [numeric](15, 4) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Invoice_outitem] (
	[Inv_outitemID] [bigint] IDENTITY (1, 1) NOT NULL ,
	[Inv_outID] [bigint] NOT NULL ,
	[LotNo] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ItemID] [smallint] NULL ,
	[VarietyID] [smallint] NULL ,
	[Qty] [numeric](15, 4) NOT NULL ,
	[GrossWT] [numeric](15, 4) NOT NULL ,
	[NetWT] [numeric](15, 4) NOT NULL ,
	[Type] [tinyint] NOT NULL ,
	[DRemarks] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Invoice_out] WITH NOCHECK ADD 
	CONSTRAINT [PK_Invoice_out] PRIMARY KEY  CLUSTERED 
	(
		[Inv_outID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Invoice_outitem] WITH NOCHECK ADD 
	CONSTRAINT [PK_Invoice_outitem] PRIMARY KEY  CLUSTERED 
	(
		[Inv_outitemID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Invoice_out] ADD 
	CONSTRAINT [DF_Invoice_out_ReadOnly] DEFAULT (0) FOR [ReadOnly],
	CONSTRAINT [DF_Invoice_out_LoginID] DEFAULT (1) FOR [LoginID],
	CONSTRAINT [DF_Invoice_out_HostName] DEFAULT (host_name()) FOR [HostName],
	CONSTRAINT [DF_Invoice_out_EntryDateTime] DEFAULT (getdate()) FOR [EntryDateTime],
	CONSTRAINT [DF_Invoice_out_SumQTY] DEFAULT (0) FOR [SumQTY],
	CONSTRAINT [DF_Invoice_out_GrossWT] DEFAULT (0) FOR [SUMGrossWT],
	CONSTRAINT [DF_Invoice_out_SUMNetWT] DEFAULT (0) FOR [SUMNetWT]
GO

ALTER TABLE [dbo].[Invoice_outitem] ADD 
	CONSTRAINT [DF_Invoice_outitem_Qty] DEFAULT (0) FOR [Qty],
	CONSTRAINT [DF_Invoice_outitem_GrossWT] DEFAULT (0) FOR [GrossWT],
	CONSTRAINT [DF_Invoice_outitem_NetWT] DEFAULT (0) FOR [NetWT],
	CONSTRAINT [DF_Invoice_outitem_Type] DEFAULT (0) FOR [Type]
GO